﻿CREATE PROCEDURE [acms].[Topic_GetBySiteIdTopicGroupPathAndName]
	@SiteId int,
	@TopicGroupPath varchar(50),
	@Name varchar(100)
AS
	SELECT a.*
	FROM Topic_View a
		Inner Join TopicGroup_View b on a.TopicGroupId = b.Id
	Where b.SiteId = @SiteId and b.Path = @TopicGroupPath and a.Name = @Name
RETURN 0;